using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VVUMSA
    {
        public DataRow Convert2VUMSA(DataRow dwInput, string ITXDBVERSION, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryVUMSA(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].NewRow();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                    #region=========
         dwReturn["VUAMANDANT"] = " ".PadRight(2 ); 
         dwReturn["VUARENR"] = " ".PadRight(8 ); 
         dwReturn["VUAREPOS"] = " ".PadRight(3 ); 
         dwReturn["VUASPLPOS"] = " ".PadRight(4 ); 
         dwReturn["VUAREART"] = " ".PadRight(2 ); 
         dwReturn["VUAGRUND"] = " ".PadRight(3 ); 
         dwReturn["VUAREDAT"] = " ".PadRight(0 ); 
         dwReturn["VUAKOAUFKRS"] = " ".PadRight(2 ); 
         dwReturn["VUAKOAUFLFD"] = " ".PadRight(6 ); 
         dwReturn["VUAKOAUFPOS"] = " ".PadRight(3 ); 
         dwReturn["VUAKOAUFART"] = " ".PadRight(2 ); 
         dwReturn["VUAKOAUFKRS1"] = " ".PadRight(2 ); 
         dwReturn["VUAKOAUFLFD1"] = " ".PadRight(6 ); 
         dwReturn["VUAKOAUFPOS1"] = " ".PadRight(3 ); 
         dwReturn["VUAKOAUFART1"] = " ".PadRight(2 ); 
         dwReturn["VUAKUNDNRKO"] = " ".PadRight(8 ); 
         dwReturn["VUAAUFKRS"] = " ".PadRight(2 ); 
         dwReturn["VUAAUFLFD"] = " ".PadRight(6 ); 
         dwReturn["VUAAUFPOS"] = " ".PadRight(3 ); 
         dwReturn["VUAKUNDNRRE"] = " ".PadRight(8 ); 
         dwReturn["VUAADRSLR"] = " ".PadRight(8 ); 
         dwReturn["VUAERSTAKZ"] = " ".PadRight(1 ); 
         dwReturn["VUAPOSTYP"] = " ".PadRight(3 ); 
         dwReturn["VUACOUPON"] = " ".PadRight(1 ); 
         dwReturn["VUAORDER"] = " ".PadRight(4 ); 
         dwReturn["VUAPRGRP"] = " ".PadRight(8 ); 
         dwReturn["VUAAEDAT"] = " ".PadRight(0 ); 
         dwReturn["VUAIAEDAT"] = " ".PadRight(0 ); 
         dwReturn["VUAMUSTER"] = " ".PadRight(1 ); 
         dwReturn["VUAVB"] = " ".PadRight(3 ); 
         dwReturn["VUAVG"] = " ".PadRight(3 ); 
         dwReturn["VUASACHBE"] = " ".PadRight(8 ); 
         dwReturn["VUAVERTNR1"] = " ".PadRight(8 ); 
         dwReturn["VUAPROV1"] = " ".PadRight(0 ); 
         dwReturn["VUAVERTNR2"] = " ".PadRight(8 ); 
         dwReturn["VUAPROV2"] = " ".PadRight(0 ); 
         dwReturn["VUAVERTNR3"] = " ".PadRight(8 ); 
         dwReturn["VUAPROV3"] = " ".PadRight(0 ); 
         dwReturn["VUAVERTNR4"] = " ".PadRight(8 ); 
         dwReturn["VUAPROV4"] = " ".PadRight(0 ); 
         dwReturn["VUALIEFSCH"] = " ".PadRight(8 ); 
         dwReturn["VUALIEFBED"] = " ".PadRight(3 ); 
         dwReturn["VUAVERSLO"] = " ".PadRight(2 ); 
         dwReturn["VUAZAHLBED"] = " ".PadRight(3 ); 
         dwReturn["VUAFTAGE"] = " ".PadRight(0 ); 
         dwReturn["VUASKONP"] = " ".PadRight(0 ); 
         dwReturn["VUAPROJNR"] = " ".PadRight(5 ); 
         dwReturn["VUAKTOANR"] = " ".PadRight(0 ); 
         dwReturn["VUAPKTZAHL"] = " ".PadRight(0 ); 
         dwReturn["VUALAND"] = " ".PadRight(3 ); 
         dwReturn["VUALDNR"] = " ".PadRight(3 ); 
         dwReturn["VUALDCODE"] = " ".PadRight(2 ); 
         dwReturn["VUAKZINLEXP"] = " ".PadRight(1 ); 
         dwReturn["VUAWR"] = " ".PadRight(2 ); 
         dwReturn["VUAPLZ"] = " ".PadRight(12 ); 
         dwReturn["VUABEZIRK"] = " ".PadRight(2 ); 
         dwReturn["VUAGEBIET"] = " ".PadRight(3 ); 
         dwReturn["VUASTLAND"] = " ".PadRight(2 ); 
         dwReturn["VUASTREGBEZ"] = " ".PadRight(2 ); 
         dwReturn["VUASTKREIS"] = " ".PadRight(2 ); 
         dwReturn["VUASTORT"] = " ".PadRight(3 ); 
         dwReturn["VUAKUNDNR"] = " ".PadRight(8 ); 
         dwReturn["VUADEBITOR"] = " ".PadRight(8 ); 
         dwReturn["VUAVERBNR"] = " ".PadRight(8 ); 
         dwReturn["VUAZENTRR"] = " ".PadRight(1 ); 
         dwReturn["VUAZENTR"] = " ".PadRight(8 ); 
         dwReturn["VUAUVERBKZ"] = " ".PadRight(1 ); 
         dwReturn["VUABRANCHE"] = " ".PadRight(3 ); 
         dwReturn["VUAABNGRP"] = " ".PadRight(3 ); 
         dwReturn["VUAABCKL"] = " ".PadRight(1 ); 
         dwReturn["VUAKONZERN"] = " ".PadRight(1 ); 
         dwReturn["VUAKUNDNRST"] = " ".PadRight(8 ); 
         dwReturn["VUAABNGRPST"] = " ".PadRight(3 ); 
         dwReturn["VUAKUNDNRL"] = " ".PadRight(8 ); 
         dwReturn["VUAADRSLL"] = " ".PadRight(8 ); 
         dwReturn["VUAMWSTID"] = " ".PadRight(20 ); 
         dwReturn["VUAPRDGR"] = " ".PadRight(3 ); 
         dwReturn["VUAARTGRP"] = " ".PadRight(3 ); 
         dwReturn["VUAZIELGR"] = " ".PadRight(4 ); 
         dwReturn["VUAPVGRP"] = " ".PadRight(3 ); 
         dwReturn["VUARGRQM"] = " ".PadRight(0 ); 
         dwReturn["VUAFGRQM"] = " ".PadRight(0 ); 
         dwReturn["VUARFDDIS"] = " ".PadRight(0 ); 
         dwReturn["VUAOBERKOLL"] = " ".PadRight(5 ); 
         dwReturn["VUAKOLL"] = " ".PadRight(5 ); 
         dwReturn["VUAVART"] = " ".PadRight(24 ); 
         dwReturn["VUAVFARBEZS"] = " ".PadRight(11 ); 
         dwReturn["VUAGROESSE"] = " ".PadRight(7 ); 
         dwReturn["VUAVAUFMART"] = " ".PadRight(2 ); 
         dwReturn["VUAVERPSL"] = " ".PadRight(3 ); 
         dwReturn["VUALIEFSG"] = " ".PadRight(1 ); 
         dwReturn["VUAZOLLTNR"] = " ".PadRight(20 ); 
         dwReturn["VUASTATWNR"] = " ".PadRight(12 ); 
         dwReturn["VUADPART"] = " ".PadRight(37 ); 
         dwReturn["VUAPWAKZ"] = " ".PadRight(1 ); 
         dwReturn["VUAPART"] = " ".PadRight(20 ); 
         dwReturn["VUAPZUSATZ"] = " ".PadRight(40 ); 
         dwReturn["VUAPVAR"] = " ".PadRight(3 ); 
         dwReturn["VUAPRODZS"] = " ".PadRight(2 ); 
         dwReturn["VUASPKZ"] = " ".PadRight(1 ); 
         dwReturn["VUAPLART"] = " ".PadRight(20 ); 
         dwReturn["VUAAUFTRMENGE"] = " ".PadRight(0 ); 
         dwReturn["VUAMEEH"] = " ".PadRight(3 ); 
         dwReturn["VUAMEEHGRP"] = " ".PadRight(1 ); 
         dwReturn["VUAMEEHFKT"] = " ".PadRight(12 ); 
         dwReturn["VUAMENGE1"] = " ".PadRight(0 ); 
         dwReturn["VUAMENGE2"] = " ".PadRight(0 ); 
         dwReturn["VUAMENGE3"] = " ".PadRight(0 ); 
         dwReturn["VUAMENGE4"] = " ".PadRight(0 ); 
         dwReturn["VUAMTRBRT"] = " ".PadRight(0 ); 
         dwReturn["VUAPREIS"] = " ".PadRight(0 ); 
         dwReturn["VUAPREH"] = " ".PadRight(3 ); 
         dwReturn["VUAPREHGRP"] = " ".PadRight(1 ); 
         dwReturn["VUAPREHFKT"] = " ".PadRight(12 ); 
         dwReturn["VUAUMSKZ"] = " ".PadRight(1 ); 
         dwReturn["VUAUMSATZAUFTR"] = " ".PadRight(0 ); 
         dwReturn["VUAUMSATZPRL"] = " ".PadRight(0 ); 
         dwReturn["VUARABWERT"] = " ".PadRight(0 ); 
         dwReturn["VUAZUABWERT"] = " ".PadRight(0 ); 
         dwReturn["VUAAUFTZUAB"] = " ".PadRight(0 ); 
         dwReturn["VUAFRACHT"] = " ".PadRight(0 ); 
         dwReturn["VUAVERSICH"] = " ".PadRight(0 ); 
         dwReturn["VUAVERP"] = " ".PadRight(0 ); 
         dwReturn["VUAUMSNTO"] = " ".PadRight(0 ); 
         dwReturn["VUAMWST"] = " ".PadRight(0 ); 
         dwReturn["VUAREGMWST"] = " ".PadRight(0 ); 
         dwReturn["VUAWAEHRSL"] = " ".PadRight(3 ); 
         dwReturn["VUAKURS"] = " ".PadRight(0 ); 
         dwReturn["VUABETRAG"] = " ".PadRight(0 ); 
         dwReturn["VUAHWAEHRSL"] = " ".PadRight(3 ); 
         dwReturn["VUAHEUROKURS"] = " ".PadRight(0 ); 
         dwReturn["VUAHEUROKURSVK"] = " ".PadRight(1 ); 
         dwReturn["VUAFEUROKURS"] = " ".PadRight(0 ); 
         dwReturn["VUAFEUROKURSVK"] = " ".PadRight(1 ); 
         dwReturn["VUASKONTOK"] = " ".PadRight(0 ); 
         dwReturn["VUASKONTOI"] = " ".PadRight(0 ); 
         dwReturn["VUABONUSK"] = " ".PadRight(0 ); 
         dwReturn["VUABONUSI"] = " ".PadRight(0 ); 
         dwReturn["VUAVHKK1"] = " ".PadRight(0 ); 
         dwReturn["VUAVHKI1"] = " ".PadRight(0 ); 
         dwReturn["VUAVHKK2"] = " ".PadRight(0 ); 
         dwReturn["VUAVHKI2"] = " ".PadRight(0 ); 
         dwReturn["VUAVHKK3"] = " ".PadRight(0 ); 
         dwReturn["VUAVHKI3"] = " ".PadRight(0 ); 
         dwReturn["VUAVHKK4"] = " ".PadRight(0 ); 
         dwReturn["VUAVHKI4"] = " ".PadRight(0 ); 
         dwReturn["VUAVHKK5"] = " ".PadRight(0 ); 
         dwReturn["VUAVHKI5"] = " ".PadRight(0 ); 
         dwReturn["VUAVHKK6"] = " ".PadRight(0 ); 
         dwReturn["VUAVHKI6"] = " ".PadRight(0 ); 
         dwReturn["VUAVHKK7"] = " ".PadRight(0 ); 
         dwReturn["VUAVHKI7"] = " ".PadRight(0 ); 
         dwReturn["VUAVHKK8"] = " ".PadRight(0 ); 
         dwReturn["VUAVHKI8"] = " ".PadRight(0 ); 
         dwReturn["VUAVHKK9"] = " ".PadRight(0 ); 
         dwReturn["VUAVHKI9"] = " ".PadRight(0 ); 
         dwReturn["VUAVHKK10"] = " ".PadRight(0 ); 
         dwReturn["VUAVHKI10"] = " ".PadRight(0 ); 
         dwReturn["VUAMEZK"] = " ".PadRight(0 ); 
         dwReturn["VUAMEZI"] = " ".PadRight(0 ); 
         dwReturn["VUAWAGK"] = " ".PadRight(0 ); 
         dwReturn["VUAWAGI"] = " ".PadRight(0 ); 
         dwReturn["VUAVVGKK1"] = " ".PadRight(0 ); 
         dwReturn["VUAVVGKI1"] = " ".PadRight(0 ); 
         dwReturn["VUAVVGKK2"] = " ".PadRight(0 ); 
         dwReturn["VUAVVGKI2"] = " ".PadRight(0 ); 
         dwReturn["VUAVVGKK3"] = " ".PadRight(0 ); 
         dwReturn["VUAVVGKI3"] = " ".PadRight(0 ); 
         dwReturn["VUAVVGKK4"] = " ".PadRight(0 ); 
         dwReturn["VUAVVGKI4"] = " ".PadRight(0 ); 
         dwReturn["VUAVVGKK5"] = " ".PadRight(0 ); 
         dwReturn["VUAVVGKI5"] = " ".PadRight(0 ); 
         dwReturn["VUAVVGKK6"] = " ".PadRight(0 ); 
         dwReturn["VUAVVGKI6"] = " ".PadRight(0 ); 
         dwReturn["VUAVVGKK7"] = " ".PadRight(0 ); 
         dwReturn["VUAVVGKI7"] = " ".PadRight(0 ); 
         dwReturn["VUAVVGKK8"] = " ".PadRight(0 ); 
         dwReturn["VUAVVGKI8"] = " ".PadRight(0 ); 
         dwReturn["VUAVVGKK9"] = " ".PadRight(0 ); 
         dwReturn["VUAVVGKI9"] = " ".PadRight(0 ); 
         dwReturn["VUAVVGKK10"] = " ".PadRight(0 ); 
         dwReturn["VUAVVGKI10"] = " ".PadRight(0 ); 
         dwReturn["VUASNKOK"] = " ".PadRight(0 ); 
         dwReturn["VUASNKOI"] = " ".PadRight(0 ); 
         dwReturn["VUASNKOAKST"] = " ".PadRight(6 ); 
         dwReturn["VUAVPK"] = " ".PadRight(0 ); 
         dwReturn["VUAVPI"] = " ".PadRight(0 ); 
         dwReturn["VUAVSK"] = " ".PadRight(0 ); 
         dwReturn["VUAVSI"] = " ".PadRight(0 ); 
         dwReturn["VUAFRK"] = " ".PadRight(0 ); 
         dwReturn["VUAFRI"] = " ".PadRight(0 ); 
         dwReturn["VUAZOLLK"] = " ".PadRight(0 ); 
         dwReturn["VUAZOLLI"] = " ".PadRight(0 ); 
         dwReturn["VUAPROVK"] = " ".PadRight(0 ); 
         dwReturn["VUAPROVI"] = " ".PadRight(0 ); 
         dwReturn["VUAEXPVGK"] = " ".PadRight(0 ); 
         dwReturn["VUASSEKK"] = " ".PadRight(0 ); 
         dwReturn["VUASSEKI"] = " ".PadRight(0 ); 
         dwReturn["VUAZINSK"] = " ".PadRight(0 ); 
         dwReturn["VUAZINSI"] = " ".PadRight(0 ); 
         dwReturn["VUAPHK1"] = " ".PadRight(0 ); 
         dwReturn["VUAPHK2"] = " ".PadRight(0 ); 
         dwReturn["VUAPHK3"] = " ".PadRight(0 ); 
         dwReturn["VUAPHK4"] = " ".PadRight(0 ); 
         dwReturn["VUAPHK5"] = " ".PadRight(0 ); 
         dwReturn["VUAPHK6"] = " ".PadRight(0 ); 
         dwReturn["VUAPHKI1"] = " ".PadRight(0 ); 
         dwReturn["VUAPHKI2"] = " ".PadRight(0 ); 
         dwReturn["VUAPHKI3"] = " ".PadRight(0 ); 
         dwReturn["VUAPHKI4"] = " ".PadRight(0 ); 
         dwReturn["VUAPHKI5"] = " ".PadRight(0 ); 
         dwReturn["VUAPHKI6"] = " ".PadRight(0 ); 
         dwReturn["VUANTRAUF"] = " ".PadRight(0 ); 
         dwReturn["VUANTRERTR"] = " ".PadRight(0 ); 
         dwReturn["VUABONKZ"] = " ".PadRight(1 ); 
         dwReturn["VUABONABRKZ"] = " ".PadRight(1 ); 
         dwReturn["VUASOFORTBON"] = " ".PadRight(0 ); 
         dwReturn["VUABONPROZ"] = " ".PadRight(0 ); 
         dwReturn["VUABZKZ"] = " ".PadRight(1 ); 
         dwReturn["VUAKZKALK"] = " ".PadRight(1 ); 
         dwReturn["VUABONABRA"] = " ".PadRight(0 ); 
         dwReturn["VUABONABRB"] = " ".PadRight(0 ); 
         dwReturn["VUATAGEAE"] = " ".PadRight(0 ); 
         dwReturn["VUATAGELI"] = " ".PadRight(0 ); 
         dwReturn["VUATAGEWU"] = " ".PadRight(0 ); 
         dwReturn["VUATAGEDI"] = " ".PadRight(0 ); 
         dwReturn["VUATAXKEY1"] = " ".PadRight(3 ); 
         dwReturn["VUATAXTOTAL1"] = " ".PadRight(0 ); 
         dwReturn["VUAIMPL1"] = " ".PadRight(1 ); 
         dwReturn["VUATAXKEY2"] = " ".PadRight(3 ); 
         dwReturn["VUATAXTOTAL2"] = " ".PadRight(0 ); 
         dwReturn["VUAIMPL2"] = " ".PadRight(1 ); 
         dwReturn["VUATAXKEY3"] = " ".PadRight(3 ); 
         dwReturn["VUATAXTOTAL3"] = " ".PadRight(0 ); 
         dwReturn["VUAIMPL3"] = " ".PadRight(1 ); 
         dwReturn["VUATAXKEY4"] = " ".PadRight(3 ); 
         dwReturn["VUATAXTOTAL4"] = " ".PadRight(0 ); 
         dwReturn["VUAIMPL4"] = " ".PadRight(1 ); 
         dwReturn["VUATAXKEY5"] = " ".PadRight(3 ); 
         dwReturn["VUATAXTOTAL5"] = " ".PadRight(0 ); 
         dwReturn["VUAIMPL5"] = " ".PadRight(1 ); 
         dwReturn["VUATAXKEY6"] = " ".PadRight(3 ); 
         dwReturn["VUATAXTOTAL6"] = " ".PadRight(0 ); 
         dwReturn["VUAIMPL6"] = " ".PadRight(1 ); 
         dwReturn["VUATAXKEY7"] = " ".PadRight(3 ); 
         dwReturn["VUATAXTOTAL7"] = " ".PadRight(0 ); 
         dwReturn["VUAIMPL7"] = " ".PadRight(1 ); 
         dwReturn["VUATAXKEY8"] = " ".PadRight(3 ); 
         dwReturn["VUATAXTOTAL8"] = " ".PadRight(0 ); 
         dwReturn["VUAIMPL8"] = " ".PadRight(1 ); 
         dwReturn["VUATAXKEY9"] = " ".PadRight(3 ); 
         dwReturn["VUATAXTOTAL9"] = " ".PadRight(0 ); 
         dwReturn["VUAIMPL9"] = " ".PadRight(1 ); 
         dwReturn["VUATAXKEY10"] = " ".PadRight(3 ); 
         dwReturn["VUATAXTOTAL10"] = " ".PadRight(0 ); 
         dwReturn["VUAIMPL10"] = " ".PadRight(1 ); 
         dwReturn["VUAREPOSTYP"] = " ".PadRight(1 ); 
         dwReturn["VUAAUFTYP"] = " ".PadRight(1 ); 
         dwReturn["VUAPACKTYP"] = " ".PadRight(4 ); 
         dwReturn["VUABUSIMODE"] = " ".PadRight(3 ); 
         dwReturn["VUANUMART"] = " ".PadRight(4 ); 
         dwReturn["VUAGARNNR1"] = " ".PadRight(5 ); 
         dwReturn["VUAGARNNR2"] = " ".PadRight(1 ); 
         dwReturn["VUADEZI"] = " ".PadRight(1 ); 
         dwReturn["VUAZUSTAND"] = " ".PadRight(4 ); 
         dwReturn["VUAOHNEREF"] = " ".PadRight(1 ); 
         dwReturn["VUADLR"] = " ".PadRight(2 ); 
         dwReturn["VUAFDVF"] = " ".PadRight(3 ); 
         dwReturn["VUAPARTIE"] = " ".PadRight(7 ); 
         dwReturn["VUAPARTIEKZ"] = " ".PadRight(1 ); 
         dwReturn["VUASPPART"] = " ".PadRight(10 ); 
         dwReturn["VUAZWPART"] = " ".PadRight(10 ); 
         dwReturn["VUAFBPART"] = " ".PadRight(10 ); 
         dwReturn["VUAURSPPART"] = " ".PadRight(10 ); 
         dwReturn["VUAKGNET"] = " ".PadRight(0 ); 
         dwReturn["VUAKKOLL"] = " ".PadRight(5 ); 
         dwReturn["VUAMKOLL"] = " ".PadRight(5 ); 
         dwReturn["VUANOCOUNT"] = " ".PadRight(1 ); 
         dwReturn["VUAFARBGRP"] = " ".PadRight(1 ); 
         dwReturn["VUAAUSART"] = " ".PadRight(4 ); 
         dwReturn["VUAGKZ1"] = " ".PadRight(1 ); 
         dwReturn["VUAPREISPRL"] = " ".PadRight(0 ); 
         dwReturn["VUAVMVB"] = " ".PadRight(3 ); 
         dwReturn["VUAVMVG"] = " ".PadRight(3 ); 
         dwReturn["VUAKEYAC"] = " ".PadRight(8 ); 
         dwReturn["VUACOUNTY"] = " ".PadRight(4 ); 
         dwReturn["VUAABSSCHL"] = " ".PadRight(3 ); 
         dwReturn["VUADISTRWEG"] = " ".PadRight(3 ); 
         dwReturn["VUAWERBSL1"] = " ".PadRight(3 ); 
         dwReturn["VUAWERBSL2"] = " ".PadRight(3 ); 
         dwReturn["VUAWERBSL3"] = " ".PadRight(3 ); 
         dwReturn["VUAWERBSL4"] = " ".PadRight(3 ); 
         dwReturn["VUAWERBSL5"] = " ".PadRight(3 ); 
         dwReturn["VUAKOLLSEG1"] = " ".PadRight(3 ); 
         dwReturn["VUAKOLLSEG2"] = " ".PadRight(3 ); 
         dwReturn["VUAKOLLSEG3"] = " ".PadRight(3 ); 
         dwReturn["VUAKOLLSEG4"] = " ".PadRight(3 ); 
         dwReturn["VUAKOLLSEG5"] = " ".PadRight(3 ); 
         dwReturn["VUAFEATURE1"] = " ".PadRight(4 ); 
         dwReturn["VUAFEATURE2"] = " ".PadRight(4 ); 
         dwReturn["VUAFEATURE3"] = " ".PadRight(4 ); 
         dwReturn["VUAFEATURE4"] = " ".PadRight(4 ); 
         dwReturn["VUAFEATURE5"] = " ".PadRight(4 ); 
         dwReturn["VUAEINSATZG"] = " ".PadRight(4 ); 
         dwReturn["VUAVERWEND"] = " ".PadRight(4 ); 
         dwReturn["VUASTDART"] = " ".PadRight(10 ); 
         dwReturn["VUAFILLER"] = " ".PadRight(81 ); 
                    #endregion
                    break;
                case "JLT":

                    break;
                default:

                    break;
            }
            if (IsConvert)
            {
                foreach (DataColumn cm in dwInput.Table.Columns)
                {
                    if (dwInput[cm.ColumnName].ToString() == "")
                        continue;
                    if (dwReturn.Table.Columns.Contains(cm.ColumnName))
                    {
                        dwReturn[cm.ColumnName] = dwInput[cm.ColumnName];
                    }
                }
            }
            return dwReturn;
        }
        public void MapVUMSA(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void SaveVUMSA(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryVUMSA(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapVUMSA(ref dwLocal, dwData);

            if (!flgExist)
            {

                InsertVUMSA(dwLocal, ITXDBVERSION);
            }
            UpdateVUMSA(dwLocal);
        }
        public void InsertVUMSA(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                    or1.CommandText = "INSERT INTO VUMSA(VAKBMANDANT, VAKBKOLL, VAKBART, VAKBKUNDNR, VAKBFARBE, VAKBKDARTNR, VAKBKDARTBEZ, VAKBKDFARBNR, VAKBANDRUCK, VAKBMEGEW, VAKBMENGEH, VAKBGEWVON, VAKBGEWBIS, VAKBGEWCA, VAKBGEWFKT, VAKBGEWGRP, VAKBMEGFKT, VAKBMEGGRP, VAKBAENDZL, VAKBAENDBEN, VAKBAENDDAT, VAKBNEUBEN, VAKBNEUDAT, VAKBFILLER)"
                        + " VALUES (:VAKBMANDANT, :VAKBKOLL, :VAKBART, :VAKBKUNDNR, :VAKBFARBE, '                         ', '                         ', '                             ', ' ', '   ', '   ', 0, 0, ' ', '000000000000', ' ', '000000000000', ' ', 0, '        ', '000000', '        ', '      ', '                                          ')";
                    or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                //VAFMANDANT VAFKOLL VAFART VAFFARBE VAFBEZ VAFFFARBE

            }
            
            Connect2Proxy(or1);
        }
        public DataSet QueryVUMSA(DataRow dwData, int option = 1)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM VUMSA WHERE  ROWNUM<2 ";
                    break;
              
                case 99:
                    or1.CommandText = "SELECT * FROM VUMSA  WHERE ROWNUM<50";
                    break;
                default:
                    break;
            }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "VUMSA";
            Return = Result;
            return Return;
        }
        public void DeleteVUMSA(DataRow dwData, int option = 1)
        {

            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM VUMSA   WHERE  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                     or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        } 
      
        public void UpdateVUMSA(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            OracleCommand or1;
            DataSet Result = new DataSet();
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command==== 
                    or1.CommandText = "UPDATE VUMSA SET "
                    +"VUAMANDANT= :VUAMANDANT,"
                    +"VUARENR= :VUARENR,"
                    +"VUAREPOS= :VUAREPOS,"
                    +"VUASPLPOS= :VUASPLPOS,"
                    +"VUAREART= :VUAREART,"
                    +"VUAGRUND= :VUAGRUND,"
                    +"VUAREDAT= :VUAREDAT,"
                    +"VUAKOAUFKRS= :VUAKOAUFKRS,"
                    +"VUAKOAUFLFD= :VUAKOAUFLFD,"
                    +"VUAKOAUFPOS= :VUAKOAUFPOS,"
                    +"VUAKOAUFART= :VUAKOAUFART,"
                    +"VUAKOAUFKRS1= :VUAKOAUFKRS1,"
                    +"VUAKOAUFLFD1= :VUAKOAUFLFD1,"
                    +"VUAKOAUFPOS1= :VUAKOAUFPOS1,"
                    +"VUAKOAUFART1= :VUAKOAUFART1,"
                    +"VUAKUNDNRKO= :VUAKUNDNRKO,"
                    +"VUAAUFKRS= :VUAAUFKRS,"
                    +"VUAAUFLFD= :VUAAUFLFD,"
                    +"VUAAUFPOS= :VUAAUFPOS,"
                    +"VUAKUNDNRRE= :VUAKUNDNRRE,"
                    +"VUAADRSLR= :VUAADRSLR,"
                    +"VUAERSTAKZ= :VUAERSTAKZ,"
                    +"VUAPOSTYP= :VUAPOSTYP,"
                    +"VUACOUPON= :VUACOUPON,"
                    +"VUAORDER= :VUAORDER,"
                    +"VUAPRGRP= :VUAPRGRP,"
                    +"VUAAEDAT= :VUAAEDAT,"
                    +"VUAIAEDAT= :VUAIAEDAT,"
                    +"VUAMUSTER= :VUAMUSTER,"
                    +"VUAVB= :VUAVB,"
                    +"VUAVG= :VUAVG,"
                    +"VUASACHBE= :VUASACHBE,"
                    +"VUAVERTNR1= :VUAVERTNR1,"
                    +"VUAPROV1= :VUAPROV1,"
                    +"VUAVERTNR2= :VUAVERTNR2,"
                    +"VUAPROV2= :VUAPROV2,"
                    +"VUAVERTNR3= :VUAVERTNR3,"
                    +"VUAPROV3= :VUAPROV3,"
                    +"VUAVERTNR4= :VUAVERTNR4,"
                    +"VUAPROV4= :VUAPROV4,"
                    +"VUALIEFSCH= :VUALIEFSCH,"
                    +"VUALIEFBED= :VUALIEFBED,"
                    +"VUAVERSLO= :VUAVERSLO,"
                    +"VUAZAHLBED= :VUAZAHLBED,"
                    +"VUAFTAGE= :VUAFTAGE,"
                    +"VUASKONP= :VUASKONP,"
                    +"VUAPROJNR= :VUAPROJNR,"
                    +"VUAKTOANR= :VUAKTOANR,"
                    +"VUAPKTZAHL= :VUAPKTZAHL,"
                    +"VUALAND= :VUALAND,"
                    +"VUALDNR= :VUALDNR,"
                    +"VUALDCODE= :VUALDCODE,"
                    +"VUAKZINLEXP= :VUAKZINLEXP,"
                    +"VUAWR= :VUAWR,"
                    +"VUAPLZ= :VUAPLZ,"
                    +"VUABEZIRK= :VUABEZIRK,"
                    +"VUAGEBIET= :VUAGEBIET,"
                    +"VUASTLAND= :VUASTLAND,"
                    +"VUASTREGBEZ= :VUASTREGBEZ,"
                    +"VUASTKREIS= :VUASTKREIS,"
                    +"VUASTORT= :VUASTORT,"
                    +"VUAKUNDNR= :VUAKUNDNR,"
                    +"VUADEBITOR= :VUADEBITOR,"
                    +"VUAVERBNR= :VUAVERBNR,"
                    +"VUAZENTRR= :VUAZENTRR,"
                    +"VUAZENTR= :VUAZENTR,"
                    +"VUAUVERBKZ= :VUAUVERBKZ,"
                    +"VUABRANCHE= :VUABRANCHE,"
                    +"VUAABNGRP= :VUAABNGRP,"
                    +"VUAABCKL= :VUAABCKL,"
                    +"VUAKONZERN= :VUAKONZERN,"
                    +"VUAKUNDNRST= :VUAKUNDNRST,"
                    +"VUAABNGRPST= :VUAABNGRPST,"
                    +"VUAKUNDNRL= :VUAKUNDNRL,"
                    +"VUAADRSLL= :VUAADRSLL,"
                    +"VUAMWSTID= :VUAMWSTID,"
                    +"VUAPRDGR= :VUAPRDGR,"
                    +"VUAARTGRP= :VUAARTGRP,"
                    +"VUAZIELGR= :VUAZIELGR,"
                    +"VUAPVGRP= :VUAPVGRP,"
                    +"VUARGRQM= :VUARGRQM,"
                    +"VUAFGRQM= :VUAFGRQM,"
                    +"VUARFDDIS= :VUARFDDIS,"
                    +"VUAOBERKOLL= :VUAOBERKOLL,"
                    +"VUAKOLL= :VUAKOLL,"
                    +"VUAVART= :VUAVART,"
                    +"VUAVFARBEZS= :VUAVFARBEZS,"
                    +"VUAGROESSE= :VUAGROESSE,"
                    +"VUAVAUFMART= :VUAVAUFMART,"
                    +"VUAVERPSL= :VUAVERPSL,"
                    +"VUALIEFSG= :VUALIEFSG,"
                    +"VUAZOLLTNR= :VUAZOLLTNR,"
                    +"VUASTATWNR= :VUASTATWNR,"
                    +"VUADPART= :VUADPART,"
                    +"VUAPWAKZ= :VUAPWAKZ,"
                    +"VUAPART= :VUAPART,"
                    +"VUAPZUSATZ= :VUAPZUSATZ,"
                    +"VUAPVAR= :VUAPVAR,"
                    +"VUAPRODZS= :VUAPRODZS,"
                    +"VUASPKZ= :VUASPKZ,"
                    +"VUAPLART= :VUAPLART,"
                    +"VUAAUFTRMENGE= :VUAAUFTRMENGE,"
                    +"VUAMEEH= :VUAMEEH,"
                    +"VUAMEEHGRP= :VUAMEEHGRP,"
                    +"VUAMEEHFKT= :VUAMEEHFKT,"
                    +"VUAMENGE1= :VUAMENGE1,"
                    +"VUAMENGE2= :VUAMENGE2,"
                    +"VUAMENGE3= :VUAMENGE3,"
                    +"VUAMENGE4= :VUAMENGE4,"
                    +"VUAMTRBRT= :VUAMTRBRT,"
                    +"VUAPREIS= :VUAPREIS,"
                    +"VUAPREH= :VUAPREH,"
                    +"VUAPREHGRP= :VUAPREHGRP,"
                    +"VUAPREHFKT= :VUAPREHFKT,"
                    +"VUAUMSKZ= :VUAUMSKZ,"
                    +"VUAUMSATZAUFTR= :VUAUMSATZAUFTR,"
                    +"VUAUMSATZPRL= :VUAUMSATZPRL,"
                    +"VUARABWERT= :VUARABWERT,"
                    +"VUAZUABWERT= :VUAZUABWERT,"
                    +"VUAAUFTZUAB= :VUAAUFTZUAB,"
                    +"VUAFRACHT= :VUAFRACHT,"
                    +"VUAVERSICH= :VUAVERSICH,"
                    +"VUAVERP= :VUAVERP,"
                    +"VUAUMSNTO= :VUAUMSNTO,"
                    +"VUAMWST= :VUAMWST,"
                    +"VUAREGMWST= :VUAREGMWST,"
                    +"VUAWAEHRSL= :VUAWAEHRSL,"
                    +"VUAKURS= :VUAKURS,"
                    +"VUABETRAG= :VUABETRAG,"
                    +"VUAHWAEHRSL= :VUAHWAEHRSL,"
                    +"VUAHEUROKURS= :VUAHEUROKURS,"
                    +"VUAHEUROKURSVK= :VUAHEUROKURSVK,"
                    +"VUAFEUROKURS= :VUAFEUROKURS,"
                    +"VUAFEUROKURSVK= :VUAFEUROKURSVK,"
                    +"VUASKONTOK= :VUASKONTOK,"
                    +"VUASKONTOI= :VUASKONTOI,"
                    +"VUABONUSK= :VUABONUSK,"
                    +"VUABONUSI= :VUABONUSI,"
                    +"VUAVHKK1= :VUAVHKK1,"
                    +"VUAVHKI1= :VUAVHKI1,"
                    +"VUAVHKK2= :VUAVHKK2,"
                    +"VUAVHKI2= :VUAVHKI2,"
                    +"VUAVHKK3= :VUAVHKK3,"
                    +"VUAVHKI3= :VUAVHKI3,"
                    +"VUAVHKK4= :VUAVHKK4,"
                    +"VUAVHKI4= :VUAVHKI4,"
                    +"VUAVHKK5= :VUAVHKK5,"
                    +"VUAVHKI5= :VUAVHKI5,"
                    +"VUAVHKK6= :VUAVHKK6,"
                    +"VUAVHKI6= :VUAVHKI6,"
                    +"VUAVHKK7= :VUAVHKK7,"
                    +"VUAVHKI7= :VUAVHKI7,"
                    +"VUAVHKK8= :VUAVHKK8,"
                    +"VUAVHKI8= :VUAVHKI8,"
                    +"VUAVHKK9= :VUAVHKK9,"
                    +"VUAVHKI9= :VUAVHKI9,"
                    +"VUAVHKK10= :VUAVHKK10,"
                    +"VUAVHKI10= :VUAVHKI10,"
                    +"VUAMEZK= :VUAMEZK,"
                    +"VUAMEZI= :VUAMEZI,"
                    +"VUAWAGK= :VUAWAGK,"
                    +"VUAWAGI= :VUAWAGI,"
                    +"VUAVVGKK1= :VUAVVGKK1,"
                    +"VUAVVGKI1= :VUAVVGKI1,"
                    +"VUAVVGKK2= :VUAVVGKK2,"
                    +"VUAVVGKI2= :VUAVVGKI2,"
                    +"VUAVVGKK3= :VUAVVGKK3,"
                    +"VUAVVGKI3= :VUAVVGKI3,"
                    +"VUAVVGKK4= :VUAVVGKK4,"
                    +"VUAVVGKI4= :VUAVVGKI4,"
                    +"VUAVVGKK5= :VUAVVGKK5,"
                    +"VUAVVGKI5= :VUAVVGKI5,"
                    +"VUAVVGKK6= :VUAVVGKK6,"
                    +"VUAVVGKI6= :VUAVVGKI6,"
                    +"VUAVVGKK7= :VUAVVGKK7,"
                    +"VUAVVGKI7= :VUAVVGKI7,"
                    +"VUAVVGKK8= :VUAVVGKK8,"
                    +"VUAVVGKI8= :VUAVVGKI8,"
                    +"VUAVVGKK9= :VUAVVGKK9,"
                    +"VUAVVGKI9= :VUAVVGKI9,"
                    +"VUAVVGKK10= :VUAVVGKK10,"
                    +"VUAVVGKI10= :VUAVVGKI10,"
                    +"VUASNKOK= :VUASNKOK,"
                    +"VUASNKOI= :VUASNKOI,"
                    +"VUASNKOAKST= :VUASNKOAKST,"
                    +"VUAVPK= :VUAVPK,"
                    +"VUAVPI= :VUAVPI,"
                    +"VUAVSK= :VUAVSK,"
                    +"VUAVSI= :VUAVSI,"
                    +"VUAFRK= :VUAFRK,"
                    +"VUAFRI= :VUAFRI,"
                    +"VUAZOLLK= :VUAZOLLK,"
                    +"VUAZOLLI= :VUAZOLLI,"
                    +"VUAPROVK= :VUAPROVK,"
                    +"VUAPROVI= :VUAPROVI,"
                    +"VUAEXPVGK= :VUAEXPVGK,"
                    +"VUASSEKK= :VUASSEKK,"
                    +"VUASSEKI= :VUASSEKI,"
                    +"VUAZINSK= :VUAZINSK,"
                    +"VUAZINSI= :VUAZINSI,"
                    +"VUAPHK1= :VUAPHK1,"
                    +"VUAPHK2= :VUAPHK2,"
                    +"VUAPHK3= :VUAPHK3,"
                    +"VUAPHK4= :VUAPHK4,"
                    +"VUAPHK5= :VUAPHK5,"
                    +"VUAPHK6= :VUAPHK6,"
                    +"VUAPHKI1= :VUAPHKI1,"
                    +"VUAPHKI2= :VUAPHKI2,"
                    +"VUAPHKI3= :VUAPHKI3,"
                    +"VUAPHKI4= :VUAPHKI4,"
                    +"VUAPHKI5= :VUAPHKI5,"
                    +"VUAPHKI6= :VUAPHKI6,"
                    +"VUANTRAUF= :VUANTRAUF,"
                    +"VUANTRERTR= :VUANTRERTR,"
                    +"VUABONKZ= :VUABONKZ,"
                    +"VUABONABRKZ= :VUABONABRKZ,"
                    +"VUASOFORTBON= :VUASOFORTBON,"
                    +"VUABONPROZ= :VUABONPROZ,"
                    +"VUABZKZ= :VUABZKZ,"
                    +"VUAKZKALK= :VUAKZKALK,"
                    +"VUABONABRA= :VUABONABRA,"
                    +"VUABONABRB= :VUABONABRB,"
                    +"VUATAGEAE= :VUATAGEAE,"
                    +"VUATAGELI= :VUATAGELI,"
                    +"VUATAGEWU= :VUATAGEWU,"
                    +"VUATAGEDI= :VUATAGEDI,"
                    +"VUATAXKEY1= :VUATAXKEY1,"
                    +"VUATAXTOTAL1= :VUATAXTOTAL1,"
                    +"VUAIMPL1= :VUAIMPL1,"
                    +"VUATAXKEY2= :VUATAXKEY2,"
                    +"VUATAXTOTAL2= :VUATAXTOTAL2,"
                    +"VUAIMPL2= :VUAIMPL2,"
                    +"VUATAXKEY3= :VUATAXKEY3,"
                    +"VUATAXTOTAL3= :VUATAXTOTAL3,"
                    +"VUAIMPL3= :VUAIMPL3,"
                    +"VUATAXKEY4= :VUATAXKEY4,"
                    +"VUATAXTOTAL4= :VUATAXTOTAL4,"
                    +"VUAIMPL4= :VUAIMPL4,"
                    +"VUATAXKEY5= :VUATAXKEY5,"
                    +"VUATAXTOTAL5= :VUATAXTOTAL5,"
                    +"VUAIMPL5= :VUAIMPL5,"
                    +"VUATAXKEY6= :VUATAXKEY6,"
                    +"VUATAXTOTAL6= :VUATAXTOTAL6,"
                    +"VUAIMPL6= :VUAIMPL6,"
                    +"VUATAXKEY7= :VUATAXKEY7,"
                    +"VUATAXTOTAL7= :VUATAXTOTAL7,"
                    +"VUAIMPL7= :VUAIMPL7,"
                    +"VUATAXKEY8= :VUATAXKEY8,"
                    +"VUATAXTOTAL8= :VUATAXTOTAL8,"
                    +"VUAIMPL8= :VUAIMPL8,"
                    +"VUATAXKEY9= :VUATAXKEY9,"
                    +"VUATAXTOTAL9= :VUATAXTOTAL9,"
                    +"VUAIMPL9= :VUAIMPL9,"
                    +"VUATAXKEY10= :VUATAXKEY10,"
                    +"VUATAXTOTAL10= :VUATAXTOTAL10,"
                    +"VUAIMPL10= :VUAIMPL10,"
                    +"VUAREPOSTYP= :VUAREPOSTYP,"
                    +"VUAAUFTYP= :VUAAUFTYP,"
                    +"VUAPACKTYP= :VUAPACKTYP,"
                    +"VUABUSIMODE= :VUABUSIMODE,"
                    +"VUANUMART= :VUANUMART,"
                    +"VUAGARNNR1= :VUAGARNNR1,"
                    +"VUAGARNNR2= :VUAGARNNR2,"
                    +"VUADEZI= :VUADEZI,"
                    +"VUAZUSTAND= :VUAZUSTAND,"
                    +"VUAOHNEREF= :VUAOHNEREF,"
                    +"VUADLR= :VUADLR,"
                    +"VUAFDVF= :VUAFDVF,"
                    +"VUAPARTIE= :VUAPARTIE,"
                    +"VUAPARTIEKZ= :VUAPARTIEKZ,"
                    +"VUASPPART= :VUASPPART,"
                    +"VUAZWPART= :VUAZWPART,"
                    +"VUAFBPART= :VUAFBPART,"
                    +"VUAURSPPART= :VUAURSPPART,"
                    +"VUAKGNET= :VUAKGNET,"
                    +"VUAKKOLL= :VUAKKOLL,"
                    +"VUAMKOLL= :VUAMKOLL,"
                    +"VUANOCOUNT= :VUANOCOUNT,"
                    +"VUAFARBGRP= :VUAFARBGRP,"
                    +"VUAAUSART= :VUAAUSART,"
                    +"VUAGKZ1= :VUAGKZ1,"
                    +"VUAPREISPRL= :VUAPREISPRL,"
                    +"VUAVMVB= :VUAVMVB,"
                    +"VUAVMVG= :VUAVMVG,"
                    +"VUAKEYAC= :VUAKEYAC,"
                    +"VUACOUNTY= :VUACOUNTY,"
                    +"VUAABSSCHL= :VUAABSSCHL,"
                    +"VUADISTRWEG= :VUADISTRWEG,"
                    +"VUAWERBSL1= :VUAWERBSL1,"
                    +"VUAWERBSL2= :VUAWERBSL2,"
                    +"VUAWERBSL3= :VUAWERBSL3,"
                    +"VUAWERBSL4= :VUAWERBSL4,"
                    +"VUAWERBSL5= :VUAWERBSL5,"
                    +"VUAKOLLSEG1= :VUAKOLLSEG1,"
                    +"VUAKOLLSEG2= :VUAKOLLSEG2,"
                    +"VUAKOLLSEG3= :VUAKOLLSEG3,"
                    +"VUAKOLLSEG4= :VUAKOLLSEG4,"
                    +"VUAKOLLSEG5= :VUAKOLLSEG5,"
                    +"VUAFEATURE1= :VUAFEATURE1,"
                    +"VUAFEATURE2= :VUAFEATURE2,"
                    +"VUAFEATURE3= :VUAFEATURE3,"
                    +"VUAFEATURE4= :VUAFEATURE4,"
                    +"VUAFEATURE5= :VUAFEATURE5,"
                    +"VUAEINSATZG= :VUAEINSATZG,"
                    +"VUAVERWEND= :VUAVERWEND,"
                    +"VUASTDART= :VUASTDART,"
                    +"VUAFILLER= :VUAFILLER,"
                        + " WHERE  "
                        + "  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                    #endregion

                    #region====Parameters====
          or1.Parameters.Add("VUAMANDANT", OracleType.NVarChar).Value = dwData["VUAMANDANT"].ToString(); 
          or1.Parameters.Add("VUARENR", OracleType.NVarChar).Value = dwData["VUARENR"].ToString(); 
          or1.Parameters.Add("VUAREPOS", OracleType.NVarChar).Value = dwData["VUAREPOS"].ToString(); 
          or1.Parameters.Add("VUASPLPOS", OracleType.NVarChar).Value = dwData["VUASPLPOS"].ToString(); 
          or1.Parameters.Add("VUAREART", OracleType.NVarChar).Value = dwData["VUAREART"].ToString(); 
          or1.Parameters.Add("VUAGRUND", OracleType.NVarChar).Value = dwData["VUAGRUND"].ToString(); 
          or1.Parameters.Add("VUAREDAT", OracleType.NVarChar).Value = dwData["VUAREDAT"].ToString(); 
          or1.Parameters.Add("VUAKOAUFKRS", OracleType.NVarChar).Value = dwData["VUAKOAUFKRS"].ToString(); 
          or1.Parameters.Add("VUAKOAUFLFD", OracleType.NVarChar).Value = dwData["VUAKOAUFLFD"].ToString(); 
          or1.Parameters.Add("VUAKOAUFPOS", OracleType.NVarChar).Value = dwData["VUAKOAUFPOS"].ToString(); 
          or1.Parameters.Add("VUAKOAUFART", OracleType.NVarChar).Value = dwData["VUAKOAUFART"].ToString(); 
          or1.Parameters.Add("VUAKOAUFKRS1", OracleType.NVarChar).Value = dwData["VUAKOAUFKRS1"].ToString(); 
          or1.Parameters.Add("VUAKOAUFLFD1", OracleType.NVarChar).Value = dwData["VUAKOAUFLFD1"].ToString(); 
          or1.Parameters.Add("VUAKOAUFPOS1", OracleType.NVarChar).Value = dwData["VUAKOAUFPOS1"].ToString(); 
          or1.Parameters.Add("VUAKOAUFART1", OracleType.NVarChar).Value = dwData["VUAKOAUFART1"].ToString(); 
          or1.Parameters.Add("VUAKUNDNRKO", OracleType.NVarChar).Value = dwData["VUAKUNDNRKO"].ToString(); 
          or1.Parameters.Add("VUAAUFKRS", OracleType.NVarChar).Value = dwData["VUAAUFKRS"].ToString(); 
          or1.Parameters.Add("VUAAUFLFD", OracleType.NVarChar).Value = dwData["VUAAUFLFD"].ToString(); 
          or1.Parameters.Add("VUAAUFPOS", OracleType.NVarChar).Value = dwData["VUAAUFPOS"].ToString(); 
          or1.Parameters.Add("VUAKUNDNRRE", OracleType.NVarChar).Value = dwData["VUAKUNDNRRE"].ToString(); 
          or1.Parameters.Add("VUAADRSLR", OracleType.NVarChar).Value = dwData["VUAADRSLR"].ToString(); 
          or1.Parameters.Add("VUAERSTAKZ", OracleType.NVarChar).Value = dwData["VUAERSTAKZ"].ToString(); 
          or1.Parameters.Add("VUAPOSTYP", OracleType.NVarChar).Value = dwData["VUAPOSTYP"].ToString(); 
          or1.Parameters.Add("VUACOUPON", OracleType.NVarChar).Value = dwData["VUACOUPON"].ToString(); 
          or1.Parameters.Add("VUAORDER", OracleType.NVarChar).Value = dwData["VUAORDER"].ToString(); 
          or1.Parameters.Add("VUAPRGRP", OracleType.NVarChar).Value = dwData["VUAPRGRP"].ToString(); 
          or1.Parameters.Add("VUAAEDAT", OracleType.NVarChar).Value = dwData["VUAAEDAT"].ToString(); 
          or1.Parameters.Add("VUAIAEDAT", OracleType.NVarChar).Value = dwData["VUAIAEDAT"].ToString(); 
          or1.Parameters.Add("VUAMUSTER", OracleType.NVarChar).Value = dwData["VUAMUSTER"].ToString(); 
          or1.Parameters.Add("VUAVB", OracleType.NVarChar).Value = dwData["VUAVB"].ToString(); 
          or1.Parameters.Add("VUAVG", OracleType.NVarChar).Value = dwData["VUAVG"].ToString(); 
          or1.Parameters.Add("VUASACHBE", OracleType.NVarChar).Value = dwData["VUASACHBE"].ToString(); 
          or1.Parameters.Add("VUAVERTNR1", OracleType.NVarChar).Value = dwData["VUAVERTNR1"].ToString(); 
          or1.Parameters.Add("VUAPROV1", OracleType.NVarChar).Value = dwData["VUAPROV1"].ToString(); 
          or1.Parameters.Add("VUAVERTNR2", OracleType.NVarChar).Value = dwData["VUAVERTNR2"].ToString(); 
          or1.Parameters.Add("VUAPROV2", OracleType.NVarChar).Value = dwData["VUAPROV2"].ToString(); 
          or1.Parameters.Add("VUAVERTNR3", OracleType.NVarChar).Value = dwData["VUAVERTNR3"].ToString(); 
          or1.Parameters.Add("VUAPROV3", OracleType.NVarChar).Value = dwData["VUAPROV3"].ToString(); 
          or1.Parameters.Add("VUAVERTNR4", OracleType.NVarChar).Value = dwData["VUAVERTNR4"].ToString(); 
          or1.Parameters.Add("VUAPROV4", OracleType.NVarChar).Value = dwData["VUAPROV4"].ToString(); 
          or1.Parameters.Add("VUALIEFSCH", OracleType.NVarChar).Value = dwData["VUALIEFSCH"].ToString(); 
          or1.Parameters.Add("VUALIEFBED", OracleType.NVarChar).Value = dwData["VUALIEFBED"].ToString(); 
          or1.Parameters.Add("VUAVERSLO", OracleType.NVarChar).Value = dwData["VUAVERSLO"].ToString(); 
          or1.Parameters.Add("VUAZAHLBED", OracleType.NVarChar).Value = dwData["VUAZAHLBED"].ToString(); 
          or1.Parameters.Add("VUAFTAGE", OracleType.NVarChar).Value = dwData["VUAFTAGE"].ToString(); 
          or1.Parameters.Add("VUASKONP", OracleType.NVarChar).Value = dwData["VUASKONP"].ToString(); 
          or1.Parameters.Add("VUAPROJNR", OracleType.NVarChar).Value = dwData["VUAPROJNR"].ToString(); 
          or1.Parameters.Add("VUAKTOANR", OracleType.NVarChar).Value = dwData["VUAKTOANR"].ToString(); 
          or1.Parameters.Add("VUAPKTZAHL", OracleType.NVarChar).Value = dwData["VUAPKTZAHL"].ToString(); 
          or1.Parameters.Add("VUALAND", OracleType.NVarChar).Value = dwData["VUALAND"].ToString(); 
          or1.Parameters.Add("VUALDNR", OracleType.NVarChar).Value = dwData["VUALDNR"].ToString(); 
          or1.Parameters.Add("VUALDCODE", OracleType.NVarChar).Value = dwData["VUALDCODE"].ToString(); 
          or1.Parameters.Add("VUAKZINLEXP", OracleType.NVarChar).Value = dwData["VUAKZINLEXP"].ToString(); 
          or1.Parameters.Add("VUAWR", OracleType.NVarChar).Value = dwData["VUAWR"].ToString(); 
          or1.Parameters.Add("VUAPLZ", OracleType.NVarChar).Value = dwData["VUAPLZ"].ToString(); 
          or1.Parameters.Add("VUABEZIRK", OracleType.NVarChar).Value = dwData["VUABEZIRK"].ToString(); 
          or1.Parameters.Add("VUAGEBIET", OracleType.NVarChar).Value = dwData["VUAGEBIET"].ToString(); 
          or1.Parameters.Add("VUASTLAND", OracleType.NVarChar).Value = dwData["VUASTLAND"].ToString(); 
          or1.Parameters.Add("VUASTREGBEZ", OracleType.NVarChar).Value = dwData["VUASTREGBEZ"].ToString(); 
          or1.Parameters.Add("VUASTKREIS", OracleType.NVarChar).Value = dwData["VUASTKREIS"].ToString(); 
          or1.Parameters.Add("VUASTORT", OracleType.NVarChar).Value = dwData["VUASTORT"].ToString(); 
          or1.Parameters.Add("VUAKUNDNR", OracleType.NVarChar).Value = dwData["VUAKUNDNR"].ToString(); 
          or1.Parameters.Add("VUADEBITOR", OracleType.NVarChar).Value = dwData["VUADEBITOR"].ToString(); 
          or1.Parameters.Add("VUAVERBNR", OracleType.NVarChar).Value = dwData["VUAVERBNR"].ToString(); 
          or1.Parameters.Add("VUAZENTRR", OracleType.NVarChar).Value = dwData["VUAZENTRR"].ToString(); 
          or1.Parameters.Add("VUAZENTR", OracleType.NVarChar).Value = dwData["VUAZENTR"].ToString(); 
          or1.Parameters.Add("VUAUVERBKZ", OracleType.NVarChar).Value = dwData["VUAUVERBKZ"].ToString(); 
          or1.Parameters.Add("VUABRANCHE", OracleType.NVarChar).Value = dwData["VUABRANCHE"].ToString(); 
          or1.Parameters.Add("VUAABNGRP", OracleType.NVarChar).Value = dwData["VUAABNGRP"].ToString(); 
          or1.Parameters.Add("VUAABCKL", OracleType.NVarChar).Value = dwData["VUAABCKL"].ToString(); 
          or1.Parameters.Add("VUAKONZERN", OracleType.NVarChar).Value = dwData["VUAKONZERN"].ToString(); 
          or1.Parameters.Add("VUAKUNDNRST", OracleType.NVarChar).Value = dwData["VUAKUNDNRST"].ToString(); 
          or1.Parameters.Add("VUAABNGRPST", OracleType.NVarChar).Value = dwData["VUAABNGRPST"].ToString(); 
          or1.Parameters.Add("VUAKUNDNRL", OracleType.NVarChar).Value = dwData["VUAKUNDNRL"].ToString(); 
          or1.Parameters.Add("VUAADRSLL", OracleType.NVarChar).Value = dwData["VUAADRSLL"].ToString(); 
          or1.Parameters.Add("VUAMWSTID", OracleType.NVarChar).Value = dwData["VUAMWSTID"].ToString(); 
          or1.Parameters.Add("VUAPRDGR", OracleType.NVarChar).Value = dwData["VUAPRDGR"].ToString(); 
          or1.Parameters.Add("VUAARTGRP", OracleType.NVarChar).Value = dwData["VUAARTGRP"].ToString(); 
          or1.Parameters.Add("VUAZIELGR", OracleType.NVarChar).Value = dwData["VUAZIELGR"].ToString(); 
          or1.Parameters.Add("VUAPVGRP", OracleType.NVarChar).Value = dwData["VUAPVGRP"].ToString(); 
          or1.Parameters.Add("VUARGRQM", OracleType.NVarChar).Value = dwData["VUARGRQM"].ToString(); 
          or1.Parameters.Add("VUAFGRQM", OracleType.NVarChar).Value = dwData["VUAFGRQM"].ToString(); 
          or1.Parameters.Add("VUARFDDIS", OracleType.NVarChar).Value = dwData["VUARFDDIS"].ToString(); 
          or1.Parameters.Add("VUAOBERKOLL", OracleType.NVarChar).Value = dwData["VUAOBERKOLL"].ToString(); 
          or1.Parameters.Add("VUAKOLL", OracleType.NVarChar).Value = dwData["VUAKOLL"].ToString(); 
          or1.Parameters.Add("VUAVART", OracleType.NVarChar).Value = dwData["VUAVART"].ToString(); 
          or1.Parameters.Add("VUAVFARBEZS", OracleType.NVarChar).Value = dwData["VUAVFARBEZS"].ToString(); 
          or1.Parameters.Add("VUAGROESSE", OracleType.NVarChar).Value = dwData["VUAGROESSE"].ToString(); 
          or1.Parameters.Add("VUAVAUFMART", OracleType.NVarChar).Value = dwData["VUAVAUFMART"].ToString(); 
          or1.Parameters.Add("VUAVERPSL", OracleType.NVarChar).Value = dwData["VUAVERPSL"].ToString(); 
          or1.Parameters.Add("VUALIEFSG", OracleType.NVarChar).Value = dwData["VUALIEFSG"].ToString(); 
          or1.Parameters.Add("VUAZOLLTNR", OracleType.NVarChar).Value = dwData["VUAZOLLTNR"].ToString(); 
          or1.Parameters.Add("VUASTATWNR", OracleType.NVarChar).Value = dwData["VUASTATWNR"].ToString(); 
          or1.Parameters.Add("VUADPART", OracleType.NVarChar).Value = dwData["VUADPART"].ToString(); 
          or1.Parameters.Add("VUAPWAKZ", OracleType.NVarChar).Value = dwData["VUAPWAKZ"].ToString(); 
          or1.Parameters.Add("VUAPART", OracleType.NVarChar).Value = dwData["VUAPART"].ToString(); 
          or1.Parameters.Add("VUAPZUSATZ", OracleType.NVarChar).Value = dwData["VUAPZUSATZ"].ToString(); 
          or1.Parameters.Add("VUAPVAR", OracleType.NVarChar).Value = dwData["VUAPVAR"].ToString(); 
          or1.Parameters.Add("VUAPRODZS", OracleType.NVarChar).Value = dwData["VUAPRODZS"].ToString(); 
          or1.Parameters.Add("VUASPKZ", OracleType.NVarChar).Value = dwData["VUASPKZ"].ToString(); 
          or1.Parameters.Add("VUAPLART", OracleType.NVarChar).Value = dwData["VUAPLART"].ToString(); 
          or1.Parameters.Add("VUAAUFTRMENGE", OracleType.NVarChar).Value = dwData["VUAAUFTRMENGE"].ToString(); 
          or1.Parameters.Add("VUAMEEH", OracleType.NVarChar).Value = dwData["VUAMEEH"].ToString(); 
          or1.Parameters.Add("VUAMEEHGRP", OracleType.NVarChar).Value = dwData["VUAMEEHGRP"].ToString(); 
          or1.Parameters.Add("VUAMEEHFKT", OracleType.NVarChar).Value = dwData["VUAMEEHFKT"].ToString(); 
          or1.Parameters.Add("VUAMENGE1", OracleType.NVarChar).Value = dwData["VUAMENGE1"].ToString(); 
          or1.Parameters.Add("VUAMENGE2", OracleType.NVarChar).Value = dwData["VUAMENGE2"].ToString(); 
          or1.Parameters.Add("VUAMENGE3", OracleType.NVarChar).Value = dwData["VUAMENGE3"].ToString(); 
          or1.Parameters.Add("VUAMENGE4", OracleType.NVarChar).Value = dwData["VUAMENGE4"].ToString(); 
          or1.Parameters.Add("VUAMTRBRT", OracleType.NVarChar).Value = dwData["VUAMTRBRT"].ToString(); 
          or1.Parameters.Add("VUAPREIS", OracleType.NVarChar).Value = dwData["VUAPREIS"].ToString(); 
          or1.Parameters.Add("VUAPREH", OracleType.NVarChar).Value = dwData["VUAPREH"].ToString(); 
          or1.Parameters.Add("VUAPREHGRP", OracleType.NVarChar).Value = dwData["VUAPREHGRP"].ToString(); 
          or1.Parameters.Add("VUAPREHFKT", OracleType.NVarChar).Value = dwData["VUAPREHFKT"].ToString(); 
          or1.Parameters.Add("VUAUMSKZ", OracleType.NVarChar).Value = dwData["VUAUMSKZ"].ToString(); 
          or1.Parameters.Add("VUAUMSATZAUFTR", OracleType.NVarChar).Value = dwData["VUAUMSATZAUFTR"].ToString(); 
          or1.Parameters.Add("VUAUMSATZPRL", OracleType.NVarChar).Value = dwData["VUAUMSATZPRL"].ToString(); 
          or1.Parameters.Add("VUARABWERT", OracleType.NVarChar).Value = dwData["VUARABWERT"].ToString(); 
          or1.Parameters.Add("VUAZUABWERT", OracleType.NVarChar).Value = dwData["VUAZUABWERT"].ToString(); 
          or1.Parameters.Add("VUAAUFTZUAB", OracleType.NVarChar).Value = dwData["VUAAUFTZUAB"].ToString(); 
          or1.Parameters.Add("VUAFRACHT", OracleType.NVarChar).Value = dwData["VUAFRACHT"].ToString(); 
          or1.Parameters.Add("VUAVERSICH", OracleType.NVarChar).Value = dwData["VUAVERSICH"].ToString(); 
          or1.Parameters.Add("VUAVERP", OracleType.NVarChar).Value = dwData["VUAVERP"].ToString(); 
          or1.Parameters.Add("VUAUMSNTO", OracleType.NVarChar).Value = dwData["VUAUMSNTO"].ToString(); 
          or1.Parameters.Add("VUAMWST", OracleType.NVarChar).Value = dwData["VUAMWST"].ToString(); 
          or1.Parameters.Add("VUAREGMWST", OracleType.NVarChar).Value = dwData["VUAREGMWST"].ToString(); 
          or1.Parameters.Add("VUAWAEHRSL", OracleType.NVarChar).Value = dwData["VUAWAEHRSL"].ToString(); 
          or1.Parameters.Add("VUAKURS", OracleType.NVarChar).Value = dwData["VUAKURS"].ToString(); 
          or1.Parameters.Add("VUABETRAG", OracleType.NVarChar).Value = dwData["VUABETRAG"].ToString(); 
          or1.Parameters.Add("VUAHWAEHRSL", OracleType.NVarChar).Value = dwData["VUAHWAEHRSL"].ToString(); 
          or1.Parameters.Add("VUAHEUROKURS", OracleType.NVarChar).Value = dwData["VUAHEUROKURS"].ToString(); 
          or1.Parameters.Add("VUAHEUROKURSVK", OracleType.NVarChar).Value = dwData["VUAHEUROKURSVK"].ToString(); 
          or1.Parameters.Add("VUAFEUROKURS", OracleType.NVarChar).Value = dwData["VUAFEUROKURS"].ToString(); 
          or1.Parameters.Add("VUAFEUROKURSVK", OracleType.NVarChar).Value = dwData["VUAFEUROKURSVK"].ToString(); 
          or1.Parameters.Add("VUASKONTOK", OracleType.NVarChar).Value = dwData["VUASKONTOK"].ToString(); 
          or1.Parameters.Add("VUASKONTOI", OracleType.NVarChar).Value = dwData["VUASKONTOI"].ToString(); 
          or1.Parameters.Add("VUABONUSK", OracleType.NVarChar).Value = dwData["VUABONUSK"].ToString(); 
          or1.Parameters.Add("VUABONUSI", OracleType.NVarChar).Value = dwData["VUABONUSI"].ToString(); 
          or1.Parameters.Add("VUAVHKK1", OracleType.NVarChar).Value = dwData["VUAVHKK1"].ToString(); 
          or1.Parameters.Add("VUAVHKI1", OracleType.NVarChar).Value = dwData["VUAVHKI1"].ToString(); 
          or1.Parameters.Add("VUAVHKK2", OracleType.NVarChar).Value = dwData["VUAVHKK2"].ToString(); 
          or1.Parameters.Add("VUAVHKI2", OracleType.NVarChar).Value = dwData["VUAVHKI2"].ToString(); 
          or1.Parameters.Add("VUAVHKK3", OracleType.NVarChar).Value = dwData["VUAVHKK3"].ToString(); 
          or1.Parameters.Add("VUAVHKI3", OracleType.NVarChar).Value = dwData["VUAVHKI3"].ToString(); 
          or1.Parameters.Add("VUAVHKK4", OracleType.NVarChar).Value = dwData["VUAVHKK4"].ToString(); 
          or1.Parameters.Add("VUAVHKI4", OracleType.NVarChar).Value = dwData["VUAVHKI4"].ToString(); 
          or1.Parameters.Add("VUAVHKK5", OracleType.NVarChar).Value = dwData["VUAVHKK5"].ToString(); 
          or1.Parameters.Add("VUAVHKI5", OracleType.NVarChar).Value = dwData["VUAVHKI5"].ToString(); 
          or1.Parameters.Add("VUAVHKK6", OracleType.NVarChar).Value = dwData["VUAVHKK6"].ToString(); 
          or1.Parameters.Add("VUAVHKI6", OracleType.NVarChar).Value = dwData["VUAVHKI6"].ToString(); 
          or1.Parameters.Add("VUAVHKK7", OracleType.NVarChar).Value = dwData["VUAVHKK7"].ToString(); 
          or1.Parameters.Add("VUAVHKI7", OracleType.NVarChar).Value = dwData["VUAVHKI7"].ToString(); 
          or1.Parameters.Add("VUAVHKK8", OracleType.NVarChar).Value = dwData["VUAVHKK8"].ToString(); 
          or1.Parameters.Add("VUAVHKI8", OracleType.NVarChar).Value = dwData["VUAVHKI8"].ToString(); 
          or1.Parameters.Add("VUAVHKK9", OracleType.NVarChar).Value = dwData["VUAVHKK9"].ToString(); 
          or1.Parameters.Add("VUAVHKI9", OracleType.NVarChar).Value = dwData["VUAVHKI9"].ToString(); 
          or1.Parameters.Add("VUAVHKK10", OracleType.NVarChar).Value = dwData["VUAVHKK10"].ToString(); 
          or1.Parameters.Add("VUAVHKI10", OracleType.NVarChar).Value = dwData["VUAVHKI10"].ToString(); 
          or1.Parameters.Add("VUAMEZK", OracleType.NVarChar).Value = dwData["VUAMEZK"].ToString(); 
          or1.Parameters.Add("VUAMEZI", OracleType.NVarChar).Value = dwData["VUAMEZI"].ToString(); 
          or1.Parameters.Add("VUAWAGK", OracleType.NVarChar).Value = dwData["VUAWAGK"].ToString(); 
          or1.Parameters.Add("VUAWAGI", OracleType.NVarChar).Value = dwData["VUAWAGI"].ToString(); 
          or1.Parameters.Add("VUAVVGKK1", OracleType.NVarChar).Value = dwData["VUAVVGKK1"].ToString(); 
          or1.Parameters.Add("VUAVVGKI1", OracleType.NVarChar).Value = dwData["VUAVVGKI1"].ToString(); 
          or1.Parameters.Add("VUAVVGKK2", OracleType.NVarChar).Value = dwData["VUAVVGKK2"].ToString(); 
          or1.Parameters.Add("VUAVVGKI2", OracleType.NVarChar).Value = dwData["VUAVVGKI2"].ToString(); 
          or1.Parameters.Add("VUAVVGKK3", OracleType.NVarChar).Value = dwData["VUAVVGKK3"].ToString(); 
          or1.Parameters.Add("VUAVVGKI3", OracleType.NVarChar).Value = dwData["VUAVVGKI3"].ToString(); 
          or1.Parameters.Add("VUAVVGKK4", OracleType.NVarChar).Value = dwData["VUAVVGKK4"].ToString(); 
          or1.Parameters.Add("VUAVVGKI4", OracleType.NVarChar).Value = dwData["VUAVVGKI4"].ToString(); 
          or1.Parameters.Add("VUAVVGKK5", OracleType.NVarChar).Value = dwData["VUAVVGKK5"].ToString(); 
          or1.Parameters.Add("VUAVVGKI5", OracleType.NVarChar).Value = dwData["VUAVVGKI5"].ToString(); 
          or1.Parameters.Add("VUAVVGKK6", OracleType.NVarChar).Value = dwData["VUAVVGKK6"].ToString(); 
          or1.Parameters.Add("VUAVVGKI6", OracleType.NVarChar).Value = dwData["VUAVVGKI6"].ToString(); 
          or1.Parameters.Add("VUAVVGKK7", OracleType.NVarChar).Value = dwData["VUAVVGKK7"].ToString(); 
          or1.Parameters.Add("VUAVVGKI7", OracleType.NVarChar).Value = dwData["VUAVVGKI7"].ToString(); 
          or1.Parameters.Add("VUAVVGKK8", OracleType.NVarChar).Value = dwData["VUAVVGKK8"].ToString(); 
          or1.Parameters.Add("VUAVVGKI8", OracleType.NVarChar).Value = dwData["VUAVVGKI8"].ToString(); 
          or1.Parameters.Add("VUAVVGKK9", OracleType.NVarChar).Value = dwData["VUAVVGKK9"].ToString(); 
          or1.Parameters.Add("VUAVVGKI9", OracleType.NVarChar).Value = dwData["VUAVVGKI9"].ToString(); 
          or1.Parameters.Add("VUAVVGKK10", OracleType.NVarChar).Value = dwData["VUAVVGKK10"].ToString(); 
          or1.Parameters.Add("VUAVVGKI10", OracleType.NVarChar).Value = dwData["VUAVVGKI10"].ToString(); 
          or1.Parameters.Add("VUASNKOK", OracleType.NVarChar).Value = dwData["VUASNKOK"].ToString(); 
          or1.Parameters.Add("VUASNKOI", OracleType.NVarChar).Value = dwData["VUASNKOI"].ToString(); 
          or1.Parameters.Add("VUASNKOAKST", OracleType.NVarChar).Value = dwData["VUASNKOAKST"].ToString(); 
          or1.Parameters.Add("VUAVPK", OracleType.NVarChar).Value = dwData["VUAVPK"].ToString(); 
          or1.Parameters.Add("VUAVPI", OracleType.NVarChar).Value = dwData["VUAVPI"].ToString(); 
          or1.Parameters.Add("VUAVSK", OracleType.NVarChar).Value = dwData["VUAVSK"].ToString(); 
          or1.Parameters.Add("VUAVSI", OracleType.NVarChar).Value = dwData["VUAVSI"].ToString(); 
          or1.Parameters.Add("VUAFRK", OracleType.NVarChar).Value = dwData["VUAFRK"].ToString(); 
          or1.Parameters.Add("VUAFRI", OracleType.NVarChar).Value = dwData["VUAFRI"].ToString(); 
          or1.Parameters.Add("VUAZOLLK", OracleType.NVarChar).Value = dwData["VUAZOLLK"].ToString(); 
          or1.Parameters.Add("VUAZOLLI", OracleType.NVarChar).Value = dwData["VUAZOLLI"].ToString(); 
          or1.Parameters.Add("VUAPROVK", OracleType.NVarChar).Value = dwData["VUAPROVK"].ToString(); 
          or1.Parameters.Add("VUAPROVI", OracleType.NVarChar).Value = dwData["VUAPROVI"].ToString(); 
          or1.Parameters.Add("VUAEXPVGK", OracleType.NVarChar).Value = dwData["VUAEXPVGK"].ToString(); 
          or1.Parameters.Add("VUASSEKK", OracleType.NVarChar).Value = dwData["VUASSEKK"].ToString(); 
          or1.Parameters.Add("VUASSEKI", OracleType.NVarChar).Value = dwData["VUASSEKI"].ToString(); 
          or1.Parameters.Add("VUAZINSK", OracleType.NVarChar).Value = dwData["VUAZINSK"].ToString(); 
          or1.Parameters.Add("VUAZINSI", OracleType.NVarChar).Value = dwData["VUAZINSI"].ToString(); 
          or1.Parameters.Add("VUAPHK1", OracleType.NVarChar).Value = dwData["VUAPHK1"].ToString(); 
          or1.Parameters.Add("VUAPHK2", OracleType.NVarChar).Value = dwData["VUAPHK2"].ToString(); 
          or1.Parameters.Add("VUAPHK3", OracleType.NVarChar).Value = dwData["VUAPHK3"].ToString(); 
          or1.Parameters.Add("VUAPHK4", OracleType.NVarChar).Value = dwData["VUAPHK4"].ToString(); 
          or1.Parameters.Add("VUAPHK5", OracleType.NVarChar).Value = dwData["VUAPHK5"].ToString(); 
          or1.Parameters.Add("VUAPHK6", OracleType.NVarChar).Value = dwData["VUAPHK6"].ToString(); 
          or1.Parameters.Add("VUAPHKI1", OracleType.NVarChar).Value = dwData["VUAPHKI1"].ToString(); 
          or1.Parameters.Add("VUAPHKI2", OracleType.NVarChar).Value = dwData["VUAPHKI2"].ToString(); 
          or1.Parameters.Add("VUAPHKI3", OracleType.NVarChar).Value = dwData["VUAPHKI3"].ToString(); 
          or1.Parameters.Add("VUAPHKI4", OracleType.NVarChar).Value = dwData["VUAPHKI4"].ToString(); 
          or1.Parameters.Add("VUAPHKI5", OracleType.NVarChar).Value = dwData["VUAPHKI5"].ToString(); 
          or1.Parameters.Add("VUAPHKI6", OracleType.NVarChar).Value = dwData["VUAPHKI6"].ToString(); 
          or1.Parameters.Add("VUANTRAUF", OracleType.NVarChar).Value = dwData["VUANTRAUF"].ToString(); 
          or1.Parameters.Add("VUANTRERTR", OracleType.NVarChar).Value = dwData["VUANTRERTR"].ToString(); 
          or1.Parameters.Add("VUABONKZ", OracleType.NVarChar).Value = dwData["VUABONKZ"].ToString(); 
          or1.Parameters.Add("VUABONABRKZ", OracleType.NVarChar).Value = dwData["VUABONABRKZ"].ToString(); 
          or1.Parameters.Add("VUASOFORTBON", OracleType.NVarChar).Value = dwData["VUASOFORTBON"].ToString(); 
          or1.Parameters.Add("VUABONPROZ", OracleType.NVarChar).Value = dwData["VUABONPROZ"].ToString(); 
          or1.Parameters.Add("VUABZKZ", OracleType.NVarChar).Value = dwData["VUABZKZ"].ToString(); 
          or1.Parameters.Add("VUAKZKALK", OracleType.NVarChar).Value = dwData["VUAKZKALK"].ToString(); 
          or1.Parameters.Add("VUABONABRA", OracleType.NVarChar).Value = dwData["VUABONABRA"].ToString(); 
          or1.Parameters.Add("VUABONABRB", OracleType.NVarChar).Value = dwData["VUABONABRB"].ToString(); 
          or1.Parameters.Add("VUATAGEAE", OracleType.NVarChar).Value = dwData["VUATAGEAE"].ToString(); 
          or1.Parameters.Add("VUATAGELI", OracleType.NVarChar).Value = dwData["VUATAGELI"].ToString(); 
          or1.Parameters.Add("VUATAGEWU", OracleType.NVarChar).Value = dwData["VUATAGEWU"].ToString(); 
          or1.Parameters.Add("VUATAGEDI", OracleType.NVarChar).Value = dwData["VUATAGEDI"].ToString(); 
          or1.Parameters.Add("VUATAXKEY1", OracleType.NVarChar).Value = dwData["VUATAXKEY1"].ToString(); 
          or1.Parameters.Add("VUATAXTOTAL1", OracleType.NVarChar).Value = dwData["VUATAXTOTAL1"].ToString(); 
          or1.Parameters.Add("VUAIMPL1", OracleType.NVarChar).Value = dwData["VUAIMPL1"].ToString(); 
          or1.Parameters.Add("VUATAXKEY2", OracleType.NVarChar).Value = dwData["VUATAXKEY2"].ToString(); 
          or1.Parameters.Add("VUATAXTOTAL2", OracleType.NVarChar).Value = dwData["VUATAXTOTAL2"].ToString(); 
          or1.Parameters.Add("VUAIMPL2", OracleType.NVarChar).Value = dwData["VUAIMPL2"].ToString(); 
          or1.Parameters.Add("VUATAXKEY3", OracleType.NVarChar).Value = dwData["VUATAXKEY3"].ToString(); 
          or1.Parameters.Add("VUATAXTOTAL3", OracleType.NVarChar).Value = dwData["VUATAXTOTAL3"].ToString(); 
          or1.Parameters.Add("VUAIMPL3", OracleType.NVarChar).Value = dwData["VUAIMPL3"].ToString(); 
          or1.Parameters.Add("VUATAXKEY4", OracleType.NVarChar).Value = dwData["VUATAXKEY4"].ToString(); 
          or1.Parameters.Add("VUATAXTOTAL4", OracleType.NVarChar).Value = dwData["VUATAXTOTAL4"].ToString(); 
          or1.Parameters.Add("VUAIMPL4", OracleType.NVarChar).Value = dwData["VUAIMPL4"].ToString(); 
          or1.Parameters.Add("VUATAXKEY5", OracleType.NVarChar).Value = dwData["VUATAXKEY5"].ToString(); 
          or1.Parameters.Add("VUATAXTOTAL5", OracleType.NVarChar).Value = dwData["VUATAXTOTAL5"].ToString(); 
          or1.Parameters.Add("VUAIMPL5", OracleType.NVarChar).Value = dwData["VUAIMPL5"].ToString(); 
          or1.Parameters.Add("VUATAXKEY6", OracleType.NVarChar).Value = dwData["VUATAXKEY6"].ToString(); 
          or1.Parameters.Add("VUATAXTOTAL6", OracleType.NVarChar).Value = dwData["VUATAXTOTAL6"].ToString(); 
          or1.Parameters.Add("VUAIMPL6", OracleType.NVarChar).Value = dwData["VUAIMPL6"].ToString(); 
          or1.Parameters.Add("VUATAXKEY7", OracleType.NVarChar).Value = dwData["VUATAXKEY7"].ToString(); 
          or1.Parameters.Add("VUATAXTOTAL7", OracleType.NVarChar).Value = dwData["VUATAXTOTAL7"].ToString(); 
          or1.Parameters.Add("VUAIMPL7", OracleType.NVarChar).Value = dwData["VUAIMPL7"].ToString(); 
          or1.Parameters.Add("VUATAXKEY8", OracleType.NVarChar).Value = dwData["VUATAXKEY8"].ToString(); 
          or1.Parameters.Add("VUATAXTOTAL8", OracleType.NVarChar).Value = dwData["VUATAXTOTAL8"].ToString(); 
          or1.Parameters.Add("VUAIMPL8", OracleType.NVarChar).Value = dwData["VUAIMPL8"].ToString(); 
          or1.Parameters.Add("VUATAXKEY9", OracleType.NVarChar).Value = dwData["VUATAXKEY9"].ToString(); 
          or1.Parameters.Add("VUATAXTOTAL9", OracleType.NVarChar).Value = dwData["VUATAXTOTAL9"].ToString(); 
          or1.Parameters.Add("VUAIMPL9", OracleType.NVarChar).Value = dwData["VUAIMPL9"].ToString(); 
          or1.Parameters.Add("VUATAXKEY10", OracleType.NVarChar).Value = dwData["VUATAXKEY10"].ToString(); 
          or1.Parameters.Add("VUATAXTOTAL10", OracleType.NVarChar).Value = dwData["VUATAXTOTAL10"].ToString(); 
          or1.Parameters.Add("VUAIMPL10", OracleType.NVarChar).Value = dwData["VUAIMPL10"].ToString(); 
          or1.Parameters.Add("VUAREPOSTYP", OracleType.NVarChar).Value = dwData["VUAREPOSTYP"].ToString(); 
          or1.Parameters.Add("VUAAUFTYP", OracleType.NVarChar).Value = dwData["VUAAUFTYP"].ToString(); 
          or1.Parameters.Add("VUAPACKTYP", OracleType.NVarChar).Value = dwData["VUAPACKTYP"].ToString(); 
          or1.Parameters.Add("VUABUSIMODE", OracleType.NVarChar).Value = dwData["VUABUSIMODE"].ToString(); 
          or1.Parameters.Add("VUANUMART", OracleType.NVarChar).Value = dwData["VUANUMART"].ToString(); 
          or1.Parameters.Add("VUAGARNNR1", OracleType.NVarChar).Value = dwData["VUAGARNNR1"].ToString(); 
          or1.Parameters.Add("VUAGARNNR2", OracleType.NVarChar).Value = dwData["VUAGARNNR2"].ToString(); 
          or1.Parameters.Add("VUADEZI", OracleType.NVarChar).Value = dwData["VUADEZI"].ToString(); 
          or1.Parameters.Add("VUAZUSTAND", OracleType.NVarChar).Value = dwData["VUAZUSTAND"].ToString(); 
          or1.Parameters.Add("VUAOHNEREF", OracleType.NVarChar).Value = dwData["VUAOHNEREF"].ToString(); 
          or1.Parameters.Add("VUADLR", OracleType.NVarChar).Value = dwData["VUADLR"].ToString(); 
          or1.Parameters.Add("VUAFDVF", OracleType.NVarChar).Value = dwData["VUAFDVF"].ToString(); 
          or1.Parameters.Add("VUAPARTIE", OracleType.NVarChar).Value = dwData["VUAPARTIE"].ToString(); 
          or1.Parameters.Add("VUAPARTIEKZ", OracleType.NVarChar).Value = dwData["VUAPARTIEKZ"].ToString(); 
          or1.Parameters.Add("VUASPPART", OracleType.NVarChar).Value = dwData["VUASPPART"].ToString(); 
          or1.Parameters.Add("VUAZWPART", OracleType.NVarChar).Value = dwData["VUAZWPART"].ToString(); 
          or1.Parameters.Add("VUAFBPART", OracleType.NVarChar).Value = dwData["VUAFBPART"].ToString(); 
          or1.Parameters.Add("VUAURSPPART", OracleType.NVarChar).Value = dwData["VUAURSPPART"].ToString(); 
          or1.Parameters.Add("VUAKGNET", OracleType.NVarChar).Value = dwData["VUAKGNET"].ToString(); 
          or1.Parameters.Add("VUAKKOLL", OracleType.NVarChar).Value = dwData["VUAKKOLL"].ToString(); 
          or1.Parameters.Add("VUAMKOLL", OracleType.NVarChar).Value = dwData["VUAMKOLL"].ToString(); 
          or1.Parameters.Add("VUANOCOUNT", OracleType.NVarChar).Value = dwData["VUANOCOUNT"].ToString(); 
          or1.Parameters.Add("VUAFARBGRP", OracleType.NVarChar).Value = dwData["VUAFARBGRP"].ToString(); 
          or1.Parameters.Add("VUAAUSART", OracleType.NVarChar).Value = dwData["VUAAUSART"].ToString(); 
          or1.Parameters.Add("VUAGKZ1", OracleType.NVarChar).Value = dwData["VUAGKZ1"].ToString(); 
          or1.Parameters.Add("VUAPREISPRL", OracleType.NVarChar).Value = dwData["VUAPREISPRL"].ToString(); 
          or1.Parameters.Add("VUAVMVB", OracleType.NVarChar).Value = dwData["VUAVMVB"].ToString(); 
          or1.Parameters.Add("VUAVMVG", OracleType.NVarChar).Value = dwData["VUAVMVG"].ToString(); 
          or1.Parameters.Add("VUAKEYAC", OracleType.NVarChar).Value = dwData["VUAKEYAC"].ToString(); 
          or1.Parameters.Add("VUACOUNTY", OracleType.NVarChar).Value = dwData["VUACOUNTY"].ToString(); 
          or1.Parameters.Add("VUAABSSCHL", OracleType.NVarChar).Value = dwData["VUAABSSCHL"].ToString(); 
          or1.Parameters.Add("VUADISTRWEG", OracleType.NVarChar).Value = dwData["VUADISTRWEG"].ToString(); 
          or1.Parameters.Add("VUAWERBSL1", OracleType.NVarChar).Value = dwData["VUAWERBSL1"].ToString(); 
          or1.Parameters.Add("VUAWERBSL2", OracleType.NVarChar).Value = dwData["VUAWERBSL2"].ToString(); 
          or1.Parameters.Add("VUAWERBSL3", OracleType.NVarChar).Value = dwData["VUAWERBSL3"].ToString(); 
          or1.Parameters.Add("VUAWERBSL4", OracleType.NVarChar).Value = dwData["VUAWERBSL4"].ToString(); 
          or1.Parameters.Add("VUAWERBSL5", OracleType.NVarChar).Value = dwData["VUAWERBSL5"].ToString(); 
          or1.Parameters.Add("VUAKOLLSEG1", OracleType.NVarChar).Value = dwData["VUAKOLLSEG1"].ToString(); 
          or1.Parameters.Add("VUAKOLLSEG2", OracleType.NVarChar).Value = dwData["VUAKOLLSEG2"].ToString(); 
          or1.Parameters.Add("VUAKOLLSEG3", OracleType.NVarChar).Value = dwData["VUAKOLLSEG3"].ToString(); 
          or1.Parameters.Add("VUAKOLLSEG4", OracleType.NVarChar).Value = dwData["VUAKOLLSEG4"].ToString(); 
          or1.Parameters.Add("VUAKOLLSEG5", OracleType.NVarChar).Value = dwData["VUAKOLLSEG5"].ToString(); 
          or1.Parameters.Add("VUAFEATURE1", OracleType.NVarChar).Value = dwData["VUAFEATURE1"].ToString(); 
          or1.Parameters.Add("VUAFEATURE2", OracleType.NVarChar).Value = dwData["VUAFEATURE2"].ToString(); 
          or1.Parameters.Add("VUAFEATURE3", OracleType.NVarChar).Value = dwData["VUAFEATURE3"].ToString(); 
          or1.Parameters.Add("VUAFEATURE4", OracleType.NVarChar).Value = dwData["VUAFEATURE4"].ToString(); 
          or1.Parameters.Add("VUAFEATURE5", OracleType.NVarChar).Value = dwData["VUAFEATURE5"].ToString(); 
          or1.Parameters.Add("VUAEINSATZG", OracleType.NVarChar).Value = dwData["VUAEINSATZG"].ToString(); 
          or1.Parameters.Add("VUAVERWEND", OracleType.NVarChar).Value = dwData["VUAVERWEND"].ToString(); 
          or1.Parameters.Add("VUASTDART", OracleType.NVarChar).Value = dwData["VUASTDART"].ToString(); 
          or1.Parameters.Add("VUAFILLER", OracleType.NVarChar).Value = dwData["VUAFILLER"].ToString(); 
                    #endregion
                    break; 
                default:
                    break;
            }


            Connect2Proxy(or1);
        }
    }
}
